Dataset statistics
| Number of variables | 43 |
|---|---|
| Number of observations | 143316 |
| Missing cells | 99154 |
| Missing cells (%) | 1.6% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 79.9 MiB |
| Average record size in memory | 584.4 B |
Variable types
| NUM | 20 |
|---|---|
| BOOL | 15 |
| CAT | 8 |
Reproduction
| Analysis started | 2021-08-19 13:59:41.798015 |
|---|---|
| Analysis finished | 2021-08-19 14:01:31.621507 |
| Duration | 1 minute and 49.82 seconds |
| Version | pandas-profiling v2.7.1 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
num_referrals has constant value "0" | Constant |
num_successful_referrals has constant value "0" | Constant |
user_id has a high cardinality: 19370 distinct values | High cardinality |
city has a high cardinality: 6033 distinct values | High cardinality |
user_created_date has a high cardinality: 19370 distinct values | High cardinality |
brand_apple is highly correlated with brand_android | High correlation |
brand_android is highly correlated with brand_apple | High correlation |
attributes_notifications_marketing_email has 49577 (34.6%) missing values | Missing |
attributes_notifications_marketing_push has 49577 (34.6%) missing values | Missing |
num_contacts is highly skewed (γ1 = 23.08246913) | Skewed |
reason_engagement_split_bill_restaurant is highly skewed (γ1 = 34.53022257) | Skewed |
reason_metal_reserve_plan is highly skewed (γ1 = 28.89428889) | Skewed |
reason_made_money_request_not_split_bill is highly skewed (γ1 = 56.88835943) | Skewed |
reason_welcome_home is highly skewed (γ1 = 25.76334341) | Skewed |
reason_lost_card_order is highly skewed (γ1 = 24.48723043) | Skewed |
num_contacts has 42154 (29.4%) zeros | Zeros |
channel_push has 100132 (69.9%) zeros | Zeros |
channel_sms has 141169 (98.5%) zeros | Zeros |
channel_email has 105453 (73.6%) zeros | Zeros |
reason_reengagement_active_funds has 116895 (81.6%) zeros | Zeros |
reason_no_initial_card_use has 137904 (96.2%) zeros | Zeros |
reason_engagement_split_bill_restaurant has 141550 (98.8%) zeros | Zeros |
reason_metal_reserve_plan has 143118 (99.9%) zeros | Zeros |
reason_onboarding_tips_activated_users has 142198 (99.2%) zeros | Zeros |
reason_made_money_request_not_split_bill has 141397 (98.7%) zeros | Zeros |
reason_premium_engagement_inactive_card has 142208 (99.2%) zeros | Zeros |
reason_no_initial_card_order has 135465 (94.5%) zeros | Zeros |
reason_fifth_payment_promo has 129953 (90.7%) zeros | Zeros |
reason_welcome_home has 142522 (99.4%) zeros | Zeros |
reason_no_initial_free_promopage_card_order has 140318 (97.9%) zeros | Zeros |
reason_lost_card_order has 140069 (97.7%) zeros | Zeros |
status_sent has 84659 (59.1%) zeros | Zeros |
status_failed has 126657 (88.4%) zeros | Zeros |
| Distinct count | 19370 |
|---|---|
| Unique (%) | 13.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| c_1094 | 17 |
|---|---|
| c_827 | 17 |
| c_405 | 17 |
| c_701 | 17 |
| c_64 | 17 |
| Other values (19365) |
| Value | Count | Frequency (%) | |
| c_1094 | 17 | < 0.1% | |
| c_827 | 17 | < 0.1% | |
| c_405 | 17 | < 0.1% | |
| c_701 | 17 | < 0.1% | |
| c_64 | 17 | < 0.1% | |
| c_546 | 17 | < 0.1% | |
| c_442 | 17 | < 0.1% | |
| c_318 | 17 | < 0.1% | |
| c_470 | 17 | < 0.1% | |
| c_109 | 17 | < 0.1% | |
| Other values (19360) | 143146 | 99.9% |
Length
| Max length | 7 |
|---|---|
| Mean length | 6.266753189 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 10 | 83.3% | |
| Connector_Punctuation | 1 | 8.3% | |
| Lowercase_Letter | 1 | 8.3% |
| Value | Count | Frequency (%) | |
| Common | 11 | 91.7% | |
| Latin | 1 | 8.3% |
| Value | Count | Frequency (%) | |
| ASCII | 12 | 100.0% |
yearmonth
Real number (ℝ≥0)
| Distinct count | 17 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 201850.2132281113 |
|---|---|
| Minimum | 201801 |
| Maximum | 201905 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 201801 |
|---|---|
| 5-th percentile | 201804 |
| Q1 | 201809 |
| median | 201812 |
| Q3 | 201902 |
| 95-th percentile | 201905 |
| Maximum | 201905 |
| Range | 104 |
| Interquartile range (IQR) | 93 |
Descriptive statistics
| Standard deviation | 46.84767408 |
|---|---|
| Coefficient of variation (CV) | 0.0002320912786 |
| Kurtosis | -1.93817837 |
| Mean | 201850.2132 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 0.2270616148 |
| Sum | 2.892836516e+10 |
| Variance | 2194.704567 |
| Value | Count | Frequency (%) | |
| 201902 | 15511 | 10.8% | |
| 201901 | 14076 | 9.8% | |
| 201903 | 13949 | 9.7% | |
| 201812 | 13832 | 9.7% | |
| 201904 | 11574 | 8.1% | |
| 201811 | 11397 | 8.0% | |
| 201810 | 10434 | 7.3% | |
| 201809 | 9976 | 7.0% | |
| 201808 | 8782 | 6.1% | |
| 201905 | 8277 | 5.8% | |
| Other values (7) | 25508 | 17.8% |
| Value | Count | Frequency (%) | |
| 201801 | 951 | 0.7% | |
| 201802 | 1629 | 1.1% | |
| 201803 | 3360 | 2.3% | |
| 201804 | 3217 | 2.2% | |
| 201805 | 4430 | 3.1% |
| Value | Count | Frequency (%) | |
| 201905 | 8277 | 5.8% | |
| 201904 | 11574 | 8.1% | |
| 201903 | 13949 | 9.7% | |
| 201902 | 15511 | 10.8% | |
| 201901 | 14076 | 9.8% |
| Distinct count | 6033 |
|---|---|
| Unique (%) | 4.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| London | 13968 |
|---|---|
| Warszawa | 3259 |
| Dublin | 2960 |
| Paris | 2776 |
| Vilnius | 2771 |
| Other values (6028) |
| Value | Count | Frequency (%) | |
| London | 13968 | 9.7% | |
| Warszawa | 3259 | 2.3% | |
| Dublin | 2960 | 2.1% | |
| Paris | 2776 | 1.9% | |
| Vilnius | 2771 | 1.9% | |
| Bucharest | 1805 | 1.3% | |
| Madrid | 1394 | 1.0% | |
| Bucuresti | 1220 | 0.9% | |
| Kraków | 1103 | 0.8% | |
| Lisboa | 989 | 0.7% | |
| Other values (6023) | 111071 | 77.5% |
Length
| Max length | 53 |
|---|---|
| Mean length | 8.211372073 |
| Min length | 1 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 82 | 52.2% | |
| Uppercase_Letter | 58 | 36.9% | |
| Decimal_Number | 10 | 6.4% | |
| Other_Punctuation | 5 | 3.2% | |
| Dash_Punctuation | 1 | 0.6% | |
| Space_Separator | 1 | 0.6% |
| Value | Count | Frequency (%) | |
| Latin | 140 | 89.2% | |
| Common | 17 | 10.8% |
| Value | Count | Frequency (%) | |
| ASCII | 69 | 43.9% | |
| Latin Ext A | 47 | 29.9% | |
| Latin 1 Sup | 37 | 23.6% | |
| Latin Ext B | 4 | 2.5% |
country
Categorical
| Distinct count | 41 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| GB | |
|---|---|
| PL | |
| FR | |
| IE | 9267 |
| RO | 8081 |
| Other values (36) |
| Value | Count | Frequency (%) | |
| GB | 48115 | 33.6% | |
| PL | 17796 | 12.4% | |
| FR | 15405 | 10.7% | |
| IE | 9267 | 6.5% | |
| RO | 8081 | 5.6% | |
| ES | 6896 | 4.8% | |
| LT | 5225 | 3.6% | |
| MT | 4002 | 2.8% | |
| PT | 3927 | 2.7% | |
| CH | 3360 | 2.3% | |
| Other values (31) | 21242 | 14.8% |
Length
| Max length | 2 |
|---|---|
| Mean length | 2 |
| Min length | 2 |
| Value | Count | Frequency (%) | |
| Uppercase_Letter | 24 | 100.0% |
| Value | Count | Frequency (%) | |
| Latin | 24 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 24 | 100.0% |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 49577 |
| Missing (%) | 34.6% |
| Memory size | 1.1 MiB |
| 1 | |
|---|---|
| 0 | 10016 |
| (Missing) |
| Value | Count | Frequency (%) | |
| 1 | 83723 | 58.4% | |
| 0 | 10016 | 7.0% | |
| (Missing) | 49577 | 34.6% |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 49577 |
| Missing (%) | 34.6% |
| Memory size | 1.1 MiB |
| 1 | |
|---|---|
| 0 | 5584 |
| (Missing) |
| Value | Count | Frequency (%) | |
| 1 | 88155 | 61.5% | |
| 0 | 5584 | 3.9% | |
| (Missing) | 49577 | 34.6% |
birth_year
Real number (ℝ≥0)
| Distinct count | 69 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1983.7087624549945 |
|---|---|
| Minimum | 1929 |
| Maximum | 2001 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 1929 |
|---|---|
| 5-th percentile | 1961 |
| Q1 | 1978 |
| median | 1986 |
| Q3 | 1992 |
| 95-th percentile | 1997 |
| Maximum | 2001 |
| Range | 72 |
| Interquartile range (IQR) | 14 |
Descriptive statistics
| Standard deviation | 11.16749856 |
|---|---|
| Coefficient of variation (CV) | 0.005629605902 |
| Kurtosis | 0.8322351958 |
| Mean | 1983.708762 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | -1.047182269 |
| Sum | 284297205 |
| Variance | 124.713024 |
| Value | Count | Frequency (%) | |
| 1992 | 7282 | 5.1% | |
| 1989 | 6636 | 4.6% | |
| 1991 | 6449 | 4.5% | |
| 1990 | 6314 | 4.4% | |
| 1993 | 6285 | 4.4% | |
| 1988 | 6115 | 4.3% | |
| 1987 | 5999 | 4.2% | |
| 1986 | 5848 | 4.1% | |
| 1994 | 5736 | 4.0% | |
| 1995 | 5319 | 3.7% | |
| Other values (59) | 81333 | 56.8% |
| Value | Count | Frequency (%) | |
| 1929 | 3 | < 0.1% | |
| 1930 | 6 | < 0.1% | |
| 1934 | 28 | < 0.1% | |
| 1935 | 14 | < 0.1% | |
| 1937 | 39 | < 0.1% |
| Value | Count | Frequency (%) | |
| 2001 | 30 | < 0.1% | |
| 2000 | 1389 | 1.0% | |
| 1999 | 2378 | 1.7% | |
| 1998 | 2823 | 2.0% | |
| 1997 | 3678 | 2.6% |
| Distinct count | 19370 |
|---|---|
| Unique (%) | 13.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| 2018-01-09T21:27:48.421Z | 17 |
|---|---|
| 2018-01-26T12:09:33.688Z | 17 |
| 2018-01-21T06:56:17.505Z | 17 |
| 2018-01-10T08:16:37.710Z | 17 |
| 2018-01-03T09:55:59.552Z | 17 |
| Other values (19365) |
| Value | Count | Frequency (%) | |
| 2018-01-09T21:27:48.421Z | 17 | < 0.1% | |
| 2018-01-26T12:09:33.688Z | 17 | < 0.1% | |
| 2018-01-21T06:56:17.505Z | 17 | < 0.1% | |
| 2018-01-10T08:16:37.710Z | 17 | < 0.1% | |
| 2018-01-03T09:55:59.552Z | 17 | < 0.1% | |
| 2018-01-22T15:36:47.115Z | 17 | < 0.1% | |
| 2018-01-16T10:26:58.342Z | 17 | < 0.1% | |
| 2018-01-13T20:32:58.620Z | 17 | < 0.1% | |
| 2018-01-23T04:19:55.164Z | 17 | < 0.1% | |
| 2018-01-16T05:51:16.581Z | 17 | < 0.1% | |
| Other values (19360) | 143146 | 99.9% |
Length
| Max length | 24 |
|---|---|
| Mean length | 24 |
| Min length | 24 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 10 | 66.7% | |
| Other_Punctuation | 2 | 13.3% | |
| Uppercase_Letter | 2 | 13.3% | |
| Dash_Punctuation | 1 | 6.7% |
| Value | Count | Frequency (%) | |
| Common | 13 | 86.7% | |
| Latin | 2 | 13.3% |
| Value | Count | Frequency (%) | |
| ASCII | 15 | 100.0% |
| Distinct count | 302 |
|---|---|
| Unique (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 19.77045828797901 |
|---|---|
| Minimum | 0 |
| Maximum | 2918 |
| Zeros | 42154 |
| Zeros (%) | 29.4% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 7 |
| Q3 | 22 |
| 95-th percentile | 80 |
| Maximum | 2918 |
| Range | 2918 |
| Interquartile range (IQR) | 22 |
Descriptive statistics
| Standard deviation | 50.93285561 |
|---|---|
| Coefficient of variation (CV) | 2.576210165 |
| Kurtosis | 1081.397141 |
| Mean | 19.77045829 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | 23.08246913 |
| Sum | 2833423 |
| Variance | 2594.155781 |
| Value | Count | Frequency (%) | |
| 0 | 42154 | 29.4% | |
| 2 | 5436 | 3.8% | |
| 3 | 5304 | 3.7% | |
| 1 | 5052 | 3.5% | |
| 4 | 4856 | 3.4% | |
| 5 | 4295 | 3.0% | |
| 6 | 3906 | 2.7% | |
| 7 | 3722 | 2.6% | |
| 8 | 3582 | 2.5% | |
| 9 | 3311 | 2.3% | |
| Other values (292) | 61698 | 43.1% |
| Value | Count | Frequency (%) | |
| 0 | 42154 | 29.4% | |
| 1 | 5052 | 3.5% | |
| 2 | 5436 | 3.8% | |
| 3 | 5304 | 3.7% | |
| 4 | 4856 | 3.4% |
| Value | Count | Frequency (%) | |
| 2918 | 13 | < 0.1% | |
| 1785 | 8 | < 0.1% | |
| 1262 | 8 | < 0.1% | |
| 1071 | 7 | < 0.1% | |
| 807 | 3 | < 0.1% |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| 0 |
|---|
| Value | Count | Frequency (%) | |
| 0 | 143316 | 100.0% |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| 0 |
|---|
| Value | Count | Frequency (%) | |
| 0 | 143316 | 100.0% |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| 1 | |
|---|---|
| 0 |
| Value | Count | Frequency (%) | |
| 1 | 72215 | 50.4% | |
| 0 | 71101 | 49.6% |
brand_unknown
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| 0 | |
|---|---|
| 1 | 470 |
| Value | Count | Frequency (%) | |
| 0 | 142846 | 99.7% | |
| 1 | 470 | 0.3% |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 72685 | 50.7% | |
| 1 | 70631 | 49.3% |
plan_type_1
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| 0 | |
|---|---|
| 1 | 4918 |
| Value | Count | Frequency (%) | |
| 0 | 138398 | 96.6% | |
| 1 | 4918 | 3.4% |
plan_type_2
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| 0 | |
|---|---|
| 1 | 397 |
| Value | Count | Frequency (%) | |
| 0 | 142919 | 99.7% | |
| 1 | 397 | 0.3% |
plan_type_3
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| 0 | |
|---|---|
| 1 | 8792 |
| Value | Count | Frequency (%) | |
| 0 | 134524 | 93.9% | |
| 1 | 8792 | 6.1% |
plan_type_4
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| 0 | |
|---|---|
| 1 | 50 |
| Value | Count | Frequency (%) | |
| 0 | 143266 | > 99.9% | |
| 1 | 50 | < 0.1% |
plan_type_5
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| 0 | |
|---|---|
| 1 | 204 |
| Value | Count | Frequency (%) | |
| 0 | 143112 | 99.9% | |
| 1 | 204 | 0.1% |
plan_type_6
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| 1 | |
|---|---|
| 0 | 14361 |
| Value | Count | Frequency (%) | |
| 1 | 128955 | 90.0% | |
| 0 | 14361 | 10.0% |
user_settings_type
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 111360 | 77.7% | |
| 1 | 31956 | 22.3% |
| Distinct count | 17 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.4024882078763013 |
|---|---|
| Minimum | 0 |
| Maximum | 19 |
| Zeros | 100132 |
| Zeros (%) | 69.9% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 19 |
| Range | 19 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.7377948869 |
|---|---|
| Coefficient of variation (CV) | 1.833084479 |
| Kurtosis | 25.96829651 |
| Mean | 0.4024882079 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.22838046 |
| Sum | 57683 |
| Variance | 0.5443412951 |
| Value | Count | Frequency (%) | |
| 0 | 100132 | 69.9% | |
| 1 | 32484 | 22.7% | |
| 2 | 8292 | 5.8% | |
| 3 | 1725 | 1.2% | |
| 4 | 422 | 0.3% | |
| 5 | 118 | 0.1% | |
| 6 | 53 | < 0.1% | |
| 7 | 24 | < 0.1% | |
| 8 | 18 | < 0.1% | |
| 10 | 14 | < 0.1% | |
| Other values (7) | 34 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 100132 | 69.9% | |
| 1 | 32484 | 22.7% | |
| 2 | 8292 | 5.8% | |
| 3 | 1725 | 1.2% | |
| 4 | 422 | 0.3% |
| Value | Count | Frequency (%) | |
| 19 | 1 | < 0.1% | |
| 16 | 2 | < 0.1% | |
| 14 | 3 | < 0.1% | |
| 13 | 3 | < 0.1% | |
| 12 | 7 | < 0.1% |
| Distinct count | 8 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.020074520639705266 |
|---|---|
| Minimum | 0 |
| Maximum | 7 |
| Zeros | 141169 |
| Zeros (%) | 98.5% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 7 |
| Range | 7 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.2005686645 |
|---|---|
| Coefficient of variation (CV) | 9.991205671 |
| Kurtosis | 314.9106697 |
| Mean | 0.02007452064 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 15.65204306 |
| Sum | 2877 |
| Variance | 0.04022778916 |
| Value | Count | Frequency (%) | |
| 0 | 141169 | 98.5% | |
| 1 | 1858 | 1.3% | |
| 4 | 141 | 0.1% | |
| 2 | 86 | 0.1% | |
| 5 | 37 | < 0.1% | |
| 3 | 18 | < 0.1% | |
| 6 | 5 | < 0.1% | |
| 7 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 141169 | 98.5% | |
| 1 | 1858 | 1.3% | |
| 2 | 86 | 0.1% | |
| 3 | 18 | < 0.1% | |
| 4 | 141 | 0.1% |
| Value | Count | Frequency (%) | |
| 7 | 2 | < 0.1% | |
| 6 | 5 | < 0.1% | |
| 5 | 37 | < 0.1% | |
| 4 | 141 | 0.1% | |
| 3 | 18 | < 0.1% |
| Distinct count | 35 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.4273981969912641 |
|---|---|
| Minimum | 0 |
| Maximum | 54 |
| Zeros | 105453 |
| Zeros (%) | 73.6% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 54 |
| Range | 54 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.049417673 |
|---|---|
| Coefficient of variation (CV) | 2.455362893 |
| Kurtosis | 182.9259905 |
| Mean | 0.427398197 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 8.103069235 |
| Sum | 61253 |
| Variance | 1.101277453 |
| Value | Count | Frequency (%) | |
| 0 | 105453 | 73.6% | |
| 1 | 26870 | 18.7% | |
| 2 | 5753 | 4.0% | |
| 3 | 2338 | 1.6% | |
| 4 | 1424 | 1.0% | |
| 5 | 490 | 0.3% | |
| 6 | 413 | 0.3% | |
| 7 | 387 | 0.3% | |
| 8 | 46 | < 0.1% | |
| 9 | 27 | < 0.1% | |
| Other values (25) | 115 | 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 105453 | 73.6% | |
| 1 | 26870 | 18.7% | |
| 2 | 5753 | 4.0% | |
| 3 | 2338 | 1.6% | |
| 4 | 1424 | 1.0% |
| Value | Count | Frequency (%) | |
| 54 | 1 | < 0.1% | |
| 47 | 1 | < 0.1% | |
| 42 | 1 | < 0.1% | |
| 36 | 1 | < 0.1% | |
| 34 | 1 | < 0.1% |
| Distinct count | 18 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.2501046638198108 |
|---|---|
| Minimum | 0 |
| Maximum | 17 |
| Zeros | 116895 |
| Zeros (%) | 81.6% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 17 |
| Range | 17 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.6225772828 |
|---|---|
| Coefficient of variation (CV) | 2.489266987 |
| Kurtosis | 47.38254028 |
| Mean | 0.2501046638 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.461716015 |
| Sum | 35844 |
| Variance | 0.3876024731 |
| Value | Count | Frequency (%) | |
| 0 | 116895 | 81.6% | |
| 1 | 19385 | 13.5% | |
| 2 | 5546 | 3.9% | |
| 3 | 1068 | 0.7% | |
| 4 | 270 | 0.2% | |
| 5 | 70 | < 0.1% | |
| 6 | 21 | < 0.1% | |
| 7 | 14 | < 0.1% | |
| 8 | 12 | < 0.1% | |
| 12 | 9 | < 0.1% | |
| Other values (8) | 26 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 116895 | 81.6% | |
| 1 | 19385 | 13.5% | |
| 2 | 5546 | 3.9% | |
| 3 | 1068 | 0.7% | |
| 4 | 270 | 0.2% |
| Value | Count | Frequency (%) | |
| 17 | 1 | < 0.1% | |
| 16 | 3 | < 0.1% | |
| 15 | 1 | < 0.1% | |
| 14 | 3 | < 0.1% | |
| 13 | 2 | < 0.1% |
reason_pumpkin_payment_notification
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| 0 | |
|---|---|
| 1 | 390 |
| 2 | 150 |
| Value | Count | Frequency (%) | |
| 0 | 142776 | 99.6% | |
| 1 | 390 | 0.3% | |
| 2 | 150 | 0.1% |
Length
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 3 | 100.0% |
| Value | Count | Frequency (%) | |
| Common | 3 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 3 | 100.0% |
| Distinct count | 17 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.07829551480644172 |
|---|---|
| Minimum | 0 |
| Maximum | 26 |
| Zeros | 137904 |
| Zeros (%) | 96.2% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 26 |
| Range | 26 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.522717332 |
|---|---|
| Coefficient of variation (CV) | 6.676210422 |
| Kurtosis | 232.9615275 |
| Mean | 0.07829551481 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 11.54731775 |
| Sum | 11221 |
| Variance | 0.2732334091 |
| Value | Count | Frequency (%) | |
| 0 | 137904 | 96.2% | |
| 1 | 3211 | 2.2% | |
| 3 | 1119 | 0.8% | |
| 2 | 441 | 0.3% | |
| 7 | 213 | 0.1% | |
| 5 | 146 | 0.1% | |
| 4 | 141 | 0.1% | |
| 6 | 127 | 0.1% | |
| 21 | 5 | < 0.1% | |
| 8 | 2 | < 0.1% | |
| Other values (7) | 7 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 137904 | 96.2% | |
| 1 | 3211 | 2.2% | |
| 2 | 441 | 0.3% | |
| 3 | 1119 | 0.8% | |
| 4 | 141 | 0.1% |
| Value | Count | Frequency (%) | |
| 26 | 1 | < 0.1% | |
| 21 | 5 | < 0.1% | |
| 20 | 1 | < 0.1% | |
| 14 | 1 | < 0.1% | |
| 13 | 1 | < 0.1% |
| Distinct count | 16 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.016034497195009628 |
|---|---|
| Minimum | 0 |
| Maximum | 20 |
| Zeros | 141550 |
| Zeros (%) | 98.8% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 20 |
| Range | 20 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.2060582074 |
|---|---|
| Coefficient of variation (CV) | 12.8509304 |
| Kurtosis | 1991.11016 |
| Mean | 0.0160344972 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 34.53022257 |
| Sum | 2298 |
| Variance | 0.04245998483 |
| Value | Count | Frequency (%) | |
| 0 | 141550 | 98.8% | |
| 1 | 1628 | 1.1% | |
| 2 | 27 | < 0.1% | |
| 4 | 26 | < 0.1% | |
| 3 | 25 | < 0.1% | |
| 5 | 19 | < 0.1% | |
| 6 | 12 | < 0.1% | |
| 7 | 11 | < 0.1% | |
| 8 | 6 | < 0.1% | |
| 9 | 5 | < 0.1% | |
| Other values (6) | 7 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 141550 | 98.8% | |
| 1 | 1628 | 1.1% | |
| 2 | 27 | < 0.1% | |
| 3 | 25 | < 0.1% | |
| 4 | 26 | < 0.1% |
| Value | Count | Frequency (%) | |
| 20 | 1 | < 0.1% | |
| 17 | 1 | < 0.1% | |
| 16 | 1 | < 0.1% | |
| 14 | 1 | < 0.1% | |
| 13 | 1 | < 0.1% |
| Distinct count | 10 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.008603365988445114 |
|---|---|
| Minimum | 0 |
| Maximum | 9 |
| Zeros | 143118 |
| Zeros (%) | 99.9% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 9 |
| Range | 9 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.2392640108 |
|---|---|
| Coefficient of variation (CV) | 27.81051174 |
| Kurtosis | 856.9922831 |
| Mean | 0.008603365988 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 28.89428889 |
| Sum | 1233 |
| Variance | 0.05724726686 |
| Value | Count | Frequency (%) | |
| 0 | 143118 | 99.9% | |
| 7 | 89 | 0.1% | |
| 6 | 39 | < 0.1% | |
| 4 | 24 | < 0.1% | |
| 8 | 14 | < 0.1% | |
| 9 | 11 | < 0.1% | |
| 5 | 9 | < 0.1% | |
| 2 | 6 | < 0.1% | |
| 3 | 3 | < 0.1% | |
| 1 | 3 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 143118 | 99.9% | |
| 1 | 3 | < 0.1% | |
| 2 | 6 | < 0.1% | |
| 3 | 3 | < 0.1% | |
| 4 | 24 | < 0.1% |
| Value | Count | Frequency (%) | |
| 9 | 11 | < 0.1% | |
| 8 | 14 | < 0.1% | |
| 7 | 89 | 0.1% | |
| 6 | 39 | < 0.1% | |
| 5 | 9 | < 0.1% |
| Distinct count | 13 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.02194451422032432 |
|---|---|
| Minimum | 0 |
| Maximum | 14 |
| Zeros | 142198 |
| Zeros (%) | 99.2% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 14 |
| Range | 14 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.2785269402 |
|---|---|
| Coefficient of variation (CV) | 12.69232654 |
| Kurtosis | 288.0488755 |
| Mean | 0.02194451422 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 15.28557775 |
| Sum | 3145 |
| Variance | 0.07757725641 |
| Value | Count | Frequency (%) | |
| 0 | 142198 | 99.2% | |
| 4 | 336 | 0.2% | |
| 1 | 263 | 0.2% | |
| 3 | 237 | 0.2% | |
| 2 | 217 | 0.2% | |
| 5 | 35 | < 0.1% | |
| 7 | 14 | < 0.1% | |
| 6 | 10 | < 0.1% | |
| 8 | 2 | < 0.1% | |
| 14 | 1 | < 0.1% | |
| Other values (3) | 3 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 142198 | 99.2% | |
| 1 | 263 | 0.2% | |
| 2 | 217 | 0.2% | |
| 3 | 237 | 0.2% | |
| 4 | 336 | 0.2% |
| Value | Count | Frequency (%) | |
| 14 | 1 | < 0.1% | |
| 11 | 1 | < 0.1% | |
| 10 | 1 | < 0.1% | |
| 9 | 1 | < 0.1% | |
| 8 | 2 | < 0.1% |
| Distinct count | 32 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.02446342348377013 |
|---|---|
| Minimum | 0 |
| Maximum | 54 |
| Zeros | 141397 |
| Zeros (%) | 98.7% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 54 |
| Range | 54 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.4429433389 |
|---|---|
| Coefficient of variation (CV) | 18.10635127 |
| Kurtosis | 4622.747785 |
| Mean | 0.02446342348 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 56.88835943 |
| Sum | 3506 |
| Variance | 0.1961988015 |
| Value | Count | Frequency (%) | |
| 0 | 141397 | 98.7% | |
| 1 | 1586 | 1.1% | |
| 2 | 122 | 0.1% | |
| 3 | 50 | < 0.1% | |
| 4 | 32 | < 0.1% | |
| 5 | 31 | < 0.1% | |
| 7 | 21 | < 0.1% | |
| 6 | 20 | < 0.1% | |
| 8 | 10 | < 0.1% | |
| 10 | 6 | < 0.1% | |
| Other values (22) | 41 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 141397 | 98.7% | |
| 1 | 1586 | 1.1% | |
| 2 | 122 | 0.1% | |
| 3 | 50 | < 0.1% | |
| 4 | 32 | < 0.1% |
| Value | Count | Frequency (%) | |
| 54 | 1 | < 0.1% | |
| 47 | 1 | < 0.1% | |
| 42 | 1 | < 0.1% | |
| 35 | 1 | < 0.1% | |
| 34 | 1 | < 0.1% |
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.007842808897820202 |
|---|---|
| Minimum | 0 |
| Maximum | 4 |
| Zeros | 142208 |
| Zeros (%) | 99.2% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 4 |
| Range | 4 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.0898577447 |
|---|---|
| Coefficient of variation (CV) | 11.45734212 |
| Kurtosis | 170.1831874 |
| Mean | 0.007842808898 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 12.10518766 |
| Sum | 1124 |
| Variance | 0.008074414282 |
| Value | Count | Frequency (%) | |
| 0 | 142208 | 99.2% | |
| 1 | 1096 | 0.8% | |
| 2 | 9 | < 0.1% | |
| 3 | 2 | < 0.1% | |
| 4 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 142208 | 99.2% | |
| 1 | 1096 | 0.8% | |
| 2 | 9 | < 0.1% | |
| 3 | 2 | < 0.1% | |
| 4 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 4 | 1 | < 0.1% | |
| 3 | 2 | < 0.1% | |
| 2 | 9 | < 0.1% | |
| 1 | 1096 | 0.8% | |
| 0 | 142208 | 99.2% |
| Distinct count | 18 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.07770241982751402 |
|---|---|
| Minimum | 0 |
| Maximum | 18 |
| Zeros | 135465 |
| Zeros (%) | 94.5% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 18 |
| Range | 18 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.4291209119 |
|---|---|
| Coefficient of variation (CV) | 5.522619667 |
| Kurtosis | 224.0462675 |
| Mean | 0.07770241983 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 11.59426111 |
| Sum | 11136 |
| Variance | 0.184144757 |
| Value | Count | Frequency (%) | |
| 0 | 135465 | 94.5% | |
| 1 | 6291 | 4.4% | |
| 2 | 990 | 0.7% | |
| 3 | 183 | 0.1% | |
| 6 | 136 | 0.1% | |
| 7 | 85 | 0.1% | |
| 4 | 75 | 0.1% | |
| 5 | 72 | 0.1% | |
| 13 | 4 | < 0.1% | |
| 15 | 3 | < 0.1% | |
| Other values (8) | 12 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 135465 | 94.5% | |
| 1 | 6291 | 4.4% | |
| 2 | 990 | 0.7% | |
| 3 | 183 | 0.1% | |
| 4 | 75 | 0.1% |
| Value | Count | Frequency (%) | |
| 18 | 1 | < 0.1% | |
| 17 | 1 | < 0.1% | |
| 16 | 1 | < 0.1% | |
| 15 | 3 | < 0.1% | |
| 14 | 1 | < 0.1% |
reason_premium_engagement_fees_saved
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| 0 | |
|---|---|
| 1 | 668 |
| 2 | 5 |
| Value | Count | Frequency (%) | |
| 0 | 142643 | 99.5% | |
| 1 | 668 | 0.5% | |
| 2 | 5 | < 0.1% |
Length
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 3 | 100.0% |
| Value | Count | Frequency (%) | |
| Common | 3 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 3 | 100.0% |
| Distinct count | 13 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.1656688715844707 |
|---|---|
| Minimum | 0 |
| Maximum | 12 |
| Zeros | 129953 |
| Zeros (%) | 90.7% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 2 |
| Maximum | 12 |
| Range | 12 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.5787616994 |
|---|---|
| Coefficient of variation (CV) | 3.493484889 |
| Kurtosis | 40.30899933 |
| Mean | 0.1656688716 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.894232702 |
| Sum | 23743 |
| Variance | 0.3349651047 |
| Value | Count | Frequency (%) | |
| 0 | 129953 | 90.7% | |
| 2 | 8143 | 5.7% | |
| 1 | 4558 | 3.2% | |
| 4 | 312 | 0.2% | |
| 3 | 212 | 0.1% | |
| 6 | 49 | < 0.1% | |
| 8 | 33 | < 0.1% | |
| 10 | 25 | < 0.1% | |
| 5 | 17 | < 0.1% | |
| 7 | 6 | < 0.1% | |
| Other values (3) | 8 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 129953 | 90.7% | |
| 1 | 4558 | 3.2% | |
| 2 | 8143 | 5.7% | |
| 3 | 212 | 0.1% | |
| 4 | 312 | 0.2% |
| Value | Count | Frequency (%) | |
| 12 | 2 | < 0.1% | |
| 11 | 1 | < 0.1% | |
| 10 | 25 | < 0.1% | |
| 9 | 5 | < 0.1% | |
| 8 | 33 | < 0.1% |
| Distinct count | 8 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.006628708588015295 |
|---|---|
| Minimum | 0 |
| Maximum | 7 |
| Zeros | 142522 |
| Zeros (%) | 99.4% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 7 |
| Range | 7 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.1032460875 |
|---|---|
| Coefficient of variation (CV) | 15.57559607 |
| Kurtosis | 1014.538198 |
| Mean | 0.006628708588 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 25.76334341 |
| Sum | 950 |
| Variance | 0.01065975457 |
| Value | Count | Frequency (%) | |
| 0 | 142522 | 99.4% | |
| 1 | 710 | 0.5% | |
| 2 | 52 | < 0.1% | |
| 4 | 12 | < 0.1% | |
| 3 | 9 | < 0.1% | |
| 5 | 6 | < 0.1% | |
| 6 | 4 | < 0.1% | |
| 7 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 142522 | 99.4% | |
| 1 | 710 | 0.5% | |
| 2 | 52 | < 0.1% | |
| 3 | 9 | < 0.1% | |
| 4 | 12 | < 0.1% |
| Value | Count | Frequency (%) | |
| 7 | 1 | < 0.1% | |
| 6 | 4 | < 0.1% | |
| 5 | 6 | < 0.1% | |
| 4 | 12 | < 0.1% | |
| 3 | 9 | < 0.1% |
| Distinct count | 11 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.0380906528231321 |
|---|---|
| Minimum | 0 |
| Maximum | 10 |
| Zeros | 140318 |
| Zeros (%) | 97.9% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 10 |
| Range | 10 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.2962871706 |
|---|---|
| Coefficient of variation (CV) | 7.778474472 |
| Kurtosis | 168.8278425 |
| Mean | 0.03809065282 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 10.85521489 |
| Sum | 5459 |
| Variance | 0.08778608747 |
| Value | Count | Frequency (%) | |
| 0 | 140318 | 97.9% | |
| 2 | 1555 | 1.1% | |
| 1 | 1129 | 0.8% | |
| 3 | 205 | 0.1% | |
| 4 | 37 | < 0.1% | |
| 6 | 23 | < 0.1% | |
| 5 | 21 | < 0.1% | |
| 8 | 13 | < 0.1% | |
| 7 | 13 | < 0.1% | |
| 10 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 140318 | 97.9% | |
| 1 | 1129 | 0.8% | |
| 2 | 1555 | 1.1% | |
| 3 | 205 | 0.1% | |
| 4 | 37 | < 0.1% |
| Value | Count | Frequency (%) | |
| 10 | 1 | < 0.1% | |
| 9 | 1 | < 0.1% | |
| 8 | 13 | < 0.1% | |
| 7 | 13 | < 0.1% | |
| 6 | 23 | < 0.1% |
| Distinct count | 23 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.042884255770465264 |
|---|---|
| Minimum | 0 |
| Maximum | 28 |
| Zeros | 140069 |
| Zeros (%) | 97.7% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 28 |
| Range | 28 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.3942902091 |
|---|---|
| Coefficient of variation (CV) | 9.194288253 |
| Kurtosis | 1001.286667 |
| Mean | 0.04288425577 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 24.48723043 |
| Sum | 6146 |
| Variance | 0.155464769 |
| Value | Count | Frequency (%) | |
| 0 | 140069 | 97.7% | |
| 2 | 1680 | 1.2% | |
| 1 | 1357 | 0.9% | |
| 4 | 109 | 0.1% | |
| 3 | 17 | < 0.1% | |
| 8 | 15 | < 0.1% | |
| 6 | 14 | < 0.1% | |
| 10 | 13 | < 0.1% | |
| 14 | 8 | < 0.1% | |
| 12 | 8 | < 0.1% | |
| Other values (13) | 26 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 140069 | 97.7% | |
| 1 | 1357 | 0.9% | |
| 2 | 1680 | 1.2% | |
| 3 | 17 | < 0.1% | |
| 4 | 109 | 0.1% |
| Value | Count | Frequency (%) | |
| 28 | 1 | < 0.1% | |
| 24 | 1 | < 0.1% | |
| 22 | 1 | < 0.1% | |
| 21 | 1 | < 0.1% | |
| 20 | 3 | < 0.1% |
reason_black_friday
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| 0 | |
|---|---|
| 1 | 1999 |
| 2 | 55 |
| Value | Count | Frequency (%) | |
| 0 | 141262 | 98.6% | |
| 1 | 1999 | 1.4% | |
| 2 | 55 | < 0.1% |
Length
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 3 | 100.0% |
| Value | Count | Frequency (%) | |
| Common | 3 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 3 | 100.0% |
reason_metal_game_start
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| 0 | |
|---|---|
| 1 | 7928 |
| 2 | 194 |
| 3 | 19 |
| Value | Count | Frequency (%) | |
| 0 | 135175 | 94.3% | |
| 1 | 7928 | 5.5% | |
| 2 | 194 | 0.1% | |
| 3 | 19 | < 0.1% |
Length
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 4 | 100.0% |
| Value | Count | Frequency (%) | |
| Common | 4 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 4 | 100.0% |
reason_joining_anniversary
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| 0 | |
|---|---|
| 1 | 4158 |
| Value | Count | Frequency (%) | |
| 0 | 139158 | 97.1% | |
| 1 | 4158 | 2.9% |
| Distinct count | 10 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.6243336403472047 |
|---|---|
| Minimum | 0 |
| Maximum | 9 |
| Zeros | 84659 |
| Zeros (%) | 59.1% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 9 |
| Range | 9 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.9274017226 |
|---|---|
| Coefficient of variation (CV) | 1.485426481 |
| Kurtosis | 4.490388961 |
| Mean | 0.6243336403 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.863372896 |
| Sum | 89477 |
| Variance | 0.860073955 |
| Value | Count | Frequency (%) | |
| 0 | 84659 | 59.1% | |
| 1 | 37451 | 26.1% | |
| 2 | 14719 | 10.3% | |
| 3 | 4310 | 3.0% | |
| 4 | 1469 | 1.0% | |
| 5 | 525 | 0.4% | |
| 6 | 134 | 0.1% | |
| 7 | 41 | < 0.1% | |
| 8 | 6 | < 0.1% | |
| 9 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 84659 | 59.1% | |
| 1 | 37451 | 26.1% | |
| 2 | 14719 | 10.3% | |
| 3 | 4310 | 3.0% | |
| 4 | 1469 | 1.0% |
| Value | Count | Frequency (%) | |
| 9 | 2 | < 0.1% | |
| 8 | 6 | < 0.1% | |
| 7 | 41 | < 0.1% | |
| 6 | 134 | 0.1% | |
| 5 | 525 | 0.4% |
| Distinct count | 38 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.22562728516006586 |
|---|---|
| Minimum | 0 |
| Maximum | 54 |
| Zeros | 126657 |
| Zeros (%) | 88.4% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 54 |
| Range | 54 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.9649407253 |
|---|---|
| Coefficient of variation (CV) | 4.276702282 |
| Kurtosis | 331.3781318 |
| Mean | 0.2256272852 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 12.84817052 |
| Sum | 32336 |
| Variance | 0.9311106033 |
| Value | Count | Frequency (%) | |
| 0 | 126657 | 88.4% | |
| 1 | 10122 | 7.1% | |
| 2 | 3329 | 2.3% | |
| 3 | 1354 | 0.9% | |
| 4 | 791 | 0.6% | |
| 5 | 490 | 0.3% | |
| 6 | 137 | 0.1% | |
| 7 | 91 | 0.1% | |
| 8 | 81 | 0.1% | |
| 10 | 50 | < 0.1% | |
| Other values (28) | 214 | 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 126657 | 88.4% | |
| 1 | 10122 | 7.1% | |
| 2 | 3329 | 2.3% | |
| 3 | 1354 | 0.9% | |
| 4 | 791 | 0.6% |
| Value | Count | Frequency (%) | |
| 54 | 1 | < 0.1% | |
| 47 | 1 | < 0.1% | |
| 42 | 1 | < 0.1% | |
| 41 | 1 | < 0.1% | |
| 36 | 1 | < 0.1% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| user_id | yearmonth | city | country | attributes_notifications_marketing_email | attributes_notifications_marketing_push | birth_year | user_created_date | num_contacts | num_referrals | num_successful_referrals | brand_android | brand_unknown | brand_apple | plan_type_1 | plan_type_2 | plan_type_3 | plan_type_4 | plan_type_5 | plan_type_6 | user_settings_type | channel_push | channel_sms | channel_email | reason_reengagement_active_funds | reason_pumpkin_payment_notification | reason_no_initial_card_use | reason_engagement_split_bill_restaurant | reason_metal_reserve_plan | reason_onboarding_tips_activated_users | reason_made_money_request_not_split_bill | reason_premium_engagement_inactive_card | reason_no_initial_card_order | reason_premium_engagement_fees_saved | reason_fifth_payment_promo | reason_welcome_home | reason_no_initial_free_promopage_card_order | reason_lost_card_order | reason_black_friday | reason_metal_game_start | reason_joining_anniversary | status_sent | status_failed | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | c_0 | 201801 | Gdansk | PL | 1.0 | 1.0 | 1989 | 2018-01-13T05:15:15.599Z | 3 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 1 | c_0 | 201802 | Gdansk | PL | 1.0 | 1.0 | 1989 | 2018-01-13T05:15:15.599Z | 3 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 2 | c_0 | 201803 | Gdansk | PL | 1.0 | 1.0 | 1989 | 2018-01-13T05:15:15.599Z | 3 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 3 | c_0 | 201804 | Gdansk | PL | 1.0 | 1.0 | 1989 | 2018-01-13T05:15:15.599Z | 3 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 4 | c_0 | 201805 | Gdansk | PL | 1.0 | 1.0 | 1989 | 2018-01-13T05:15:15.599Z | 3 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 5 | c_0 | 201806 | Gdansk | PL | 1.0 | 1.0 | 1989 | 2018-01-13T05:15:15.599Z | 3 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 6 | c_0 | 201807 | Gdansk | PL | 1.0 | 1.0 | 1989 | 2018-01-13T05:15:15.599Z | 3 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 7 | c_0 | 201808 | Gdansk | PL | 1.0 | 1.0 | 1989 | 2018-01-13T05:15:15.599Z | 3 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 8 | c_0 | 201809 | Gdansk | PL | 1.0 | 1.0 | 1989 | 2018-01-13T05:15:15.599Z | 3 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 9 | c_0 | 201810 | Gdansk | PL | 1.0 | 1.0 | 1989 | 2018-01-13T05:15:15.599Z | 3 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |
Last rows
| user_id | yearmonth | city | country | attributes_notifications_marketing_email | attributes_notifications_marketing_push | birth_year | user_created_date | num_contacts | num_referrals | num_successful_referrals | brand_android | brand_unknown | brand_apple | plan_type_1 | plan_type_2 | plan_type_3 | plan_type_4 | plan_type_5 | plan_type_6 | user_settings_type | channel_push | channel_sms | channel_email | reason_reengagement_active_funds | reason_pumpkin_payment_notification | reason_no_initial_card_use | reason_engagement_split_bill_restaurant | reason_metal_reserve_plan | reason_onboarding_tips_activated_users | reason_made_money_request_not_split_bill | reason_premium_engagement_inactive_card | reason_no_initial_card_order | reason_premium_engagement_fees_saved | reason_fifth_payment_promo | reason_welcome_home | reason_no_initial_free_promopage_card_order | reason_lost_card_order | reason_black_friday | reason_metal_game_start | reason_joining_anniversary | status_sent | status_failed | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 143306 | c_9999 | 201808 | Gort | IE | NaN | NaN | 1960 | 2018-08-13T01:21:23.848Z | 7 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 143307 | c_9999 | 201809 | Gort | IE | NaN | NaN | 1960 | 2018-08-13T01:21:23.848Z | 7 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 143308 | c_9999 | 201810 | Gort | IE | NaN | NaN | 1960 | 2018-08-13T01:21:23.848Z | 7 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |
| 143309 | c_9999 | 201811 | Gort | IE | NaN | NaN | 1960 | 2018-08-13T01:21:23.848Z | 7 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |
| 143310 | c_9999 | 201812 | Gort | IE | NaN | NaN | 1960 | 2018-08-13T01:21:23.848Z | 7 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 143311 | c_9999 | 201901 | Gort | IE | NaN | NaN | 1960 | 2018-08-13T01:21:23.848Z | 7 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |
| 143312 | c_9999 | 201902 | Gort | IE | NaN | NaN | 1960 | 2018-08-13T01:21:23.848Z | 7 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 2 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 |
| 143313 | c_9999 | 201903 | Gort | IE | NaN | NaN | 1960 | 2018-08-13T01:21:23.848Z | 7 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 |
| 143314 | c_9999 | 201904 | Gort | IE | NaN | NaN | 1960 | 2018-08-13T01:21:23.848Z | 7 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 143315 | c_9999 | 201905 | Gort | IE | NaN | NaN | 1960 | 2018-08-13T01:21:23.848Z | 7 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |